From 8e4fc09c4283f02ff81ac21cb1c4e1300172cf50 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 28 Jul 2026 20:56:10 +0000 Subject: [PATCH] Explain how to manually modifiy the content of SIGHTINGS --- doc/src/analyzed/sightings.m4 | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/doc/src/analyzed/sightings.m4 b/doc/src/analyzed/sightings.m4 index 8f3dea4..90a9446 100644 --- a/doc/src/analyzed/sightings.m4 +++ b/doc/src/analyzed/sightings.m4 @@ -39,6 +39,14 @@ The SIGHTINGS table is automatically constructed by the system and cannot be manually maintained. The table's rows are computed from the SokweDB tables' content. +Manual adjustments to the SIGHTINGS table can be made by adjusting +other database content. +The |NON_BREC_SIGHTING_SOURCES| table is intended to be the primary +way of making manual adjustments to SIGHTINGS. +It is used to add arbitrary sightings of a chimpanzee. +To remove a sighting, use the |SIGHTINGS.Source| column to determine +the source of the faulty data and correct the data. + The combination of |SIGHTINGS.Date| and |SIGHTINGS.AnimID| must be unique. -- 2.34.1